Quiz: Worksheets

Practice Makes Perfect

Before creating our visualization, let's add all the data connected by INNER JOINs. Assure the Orders table is joined to the Returns table on Order ID. Additionally, assure that the Orders table is joined to the People table on the Region. Below are two images that should help you verify!

The quiz here won't follow the video directly like the first couple, so follow the directions below to answer the questions that follow.

Task Description:

Tasks to Complete:

Task List:

Join all three tables using INNER JOINs as shown in the image above.

Select Sheet 1 in the lower left corner to start building your first visualization!

Quiz 1 Below

Drag Market to the Columns and Number of Records to the Rows

Click the left margin to sort the bars.

Quiz 2 Below

Click and drag Market and Number of Records, so they are no longer shown in the display. Drag Longitude to Columns and Latitude to Rows.

Double click Country and double click Profit. You should see them move into the Marks box.

In the panel labeled Show Me click the map that looks shaded, not the one with dots.

Quiz 3 below.

Change SUM(Profit) to AVERAGE(Profit).

Quiz 4 below.

Task Feedback:

Nice Job!

QUIZ QUESTION::

Quiz 1

Match the below Tableau name to the correct definition.

ANSWER CHOICES:

Tableau Name	Definition
Dimension
Measure

SOLUTION:

Tableau Name	Definition
Measure
Dimension

SOLUTION:

LATAM

QUIZ QUESTION::

Quiz 3

Match each total profit to its appropriate country. Remember these are the profits on the returns. Countries not listed may not have had orders, or may not have had returns.

ANSWER CHOICES:

Country	Total Profit
China
India
Sweden
Argentina
Taiwan

SOLUTION:

Country	Total Profit
Sweden
India
China
Argentina
Taiwan

QUIZ QUESTION::

Quiz 4

Match each average profit to its appropriate country. Remember these are the profits on the returns. Countries not listed may not have had orders, or may not have had returns.

ANSWER CHOICES:

Country	Average Profit
United States
Pakistan
Ireland
Austria
Norway

SOLUTION:

Country	Average Profit
Pakistan
Austria
United States
Norway
Ireland